Agenda of the Video▶️: To show, List Page filtered Data in Pivot-Table-Mode.<br />Here, Worksheet = Page Data (List Page/Vouchers/Journals).<br />-------------------------------------------------------------------------------------<br />Create "Pivot Table" to *Analyze* Worksheet Data | Version: 23.2 (INDIA, Business Central).<br />-------------------------------------------------------------------------------------<br />Benefit of the▪️Analyze▪️Option❓<br />▫️When you create Pivot Tables in Business Central using the Analysis mode feature.<br />▫️This feature allows you to interact with data on list pages, and analyze it directly in the client without having to open the page in Excel, or Run a Report.<br />--------------------------------------------------------------------<br />✍️Steps are as follows: -<br />✅1. To create a Pivot Table, you can switch to Analysis Mode by adding multiple tabs that represent different tasks or views on the data.<br />✅2. Once you’re ready to Analyze data on a list page, simply turn on the Pivot Mode toggle switch and drag fields that are to be summed to the Values part.<br />✅3. Once you’re ready to Analyze data on a list page, simply turn on the Pivot Mode toggle switch and drag fields that are to be summed to the Values part.<br />✅4. You can define groups that show up in the column part of the data area by dragging fields to the Column Labels part of the Columns menu.<br />✅5. Column Grouping works best if the grouping field only contains a few values. <br />You can also apply more filters to the dataset using the Additional Filters menu of the field modifier area.<br />--------------------------------------------------------------------------------------------<br />▶️Video ContentCreator | Editor | Publisher | Speaker: Madhavi Pandey.<br />----------------------------------------------<br />This platform has been designed to provide easy solutions via Freelancing on those issues which are related with Dynamics ERPs. <br />It also includes Vlogging, Discussion on Concept based Scenarios, Online/On-Remote Short Solution for Pre & Post implementation of ERP Software. We are providing Support Services & Suggestion after Post-Implementation (on pre-payment basis).<br />_____________________________________<br />Freelancing Website: ➡️www.NavisionFunctionalExpert.com<br />_____________________________________<br />We are publishing Short-Blogs on our Freelancing Website.<br />To Read the Blog related with Navision & Business Central, visit the Website's Short-Blog Section.<br />https://navisionfunctionalexpert.com/short-blog<br />---------------------------------------------<br />Follow us on LinkedIn | Dailymotion | Instagram | Twitter | Facebook | Soundcloud
